USE DB_TCC
IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE NAME LIKE 'P_CURRICULO_REDE_SOCIAL_INCLUIR')
	DROP PROCEDURE P_CURRICULO_REDE_SOCIAL_INCLUIR
GO
CREATE PROCEDURE P_CURRICULO_REDE_SOCIAL_INCLUIR(
	@IDREDESOCIAL	INTEGER,
	@IDCURRICULO	INTEGER,
	@LINKREDESOCIAL	VARCHAR(100))
AS BEGIN
	INSERT INTO CURRICULO_REDE_SOCIAL(
		IDREDESOCIAL,
		IDCURRICULO,
		LINKREDESOCIAL,
		DTHRINCLUSAO,
		DTHRALTERACAO)
	VALUES(
		@IDREDESOCIAL,
		@IDCURRICULO,
		@LINKREDESOCIAL,
		GETDATE(),
		GETDATE())
END